Tabela CO_INVOICEITEM

Definicja tabeli CO_INVOICEITEM

Name

CO_INVOICEITEM

Code

CO_INVOICEITEM

Comment

 


Lista kolumn tabeli CO_INVOICEITEM

Name

Code

CO_INVOICEITEMID

CO_INVOICEITEMID

CO_INVOICEID

CO_INVOICEID

NAME

NAME

QUANTITY

QUANTITY

PRICENETTO

PRICENETTO

VATRATE

VATRATE

UNIT

UNIT

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_INVOICEITEMID tabeli CO_INVOICEITEM

Definicja kolumny CO_INVOICEITEMID tabeli CO_INVOICEITEM

Name

CO_INVOICEITEMID

Code

CO_INVOICEITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CO_INVOICEID tabeli CO_INVOICEITEM

Definicja kolumny CO_INVOICEID tabeli CO_INVOICEITEM

Name

CO_INVOICEID

Code

CO_INVOICEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NAME tabeli CO_INVOICEITEM

Definicja kolumny NAME tabeli CO_INVOICEITEM

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna QUANTITY tabeli CO_INVOICEITEM

Definicja kolumny QUANTITY tabeli CO_INVOICEITEM

Name

QUANTITY

Code

QUANTITY

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna PRICENETTO tabeli CO_INVOICEITEM

Definicja kolumny PRICENETTO tabeli CO_INVOICEITEM

Name

PRICENETTO

Code

PRICENETTO

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna VATRATE tabeli CO_INVOICEITEM

Definicja kolumny VATRATE tabeli CO_INVOICEITEM

Name

VATRATE

Code

VATRATE

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UNIT tabeli CO_INVOICEITEM

Definicja kolumny UNIT tabeli CO_INVOICEITEM

Name

UNIT

Code

UNIT

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_INVOICEITEM

Definicja kolumny INSERTDATE tabeli CO_INVOICEITEM

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_INVOICEITEM

Definicja kolumny INSERTINGPERSON tabeli CO_INVOICEITEM

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_INVOICEITEM

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_INVOICEITEM

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_INVOICEITEM

Definicja kolumny LASTMODIFIEDDT tabeli CO_INVOICEITEM

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_INVOICEITEM

Name

Code

Primary

PK_CO_INVOICEITEM

PK_CO_INVOICEITEM

X


Klucz PK_CO_INVOICEITEM tabeli CO_INVOICEITEM

Definicja klucza PK_CO_INVOICEITEM tabeli CO_INVOICEITEM

Name

PK_CO_INVOICEITEM

Code

PK_CO_INVOICEITEM

Primary

Yes

Comment